<?php
class ProductPriceListViewModel extends ViewModel {
	public $viewFields = array (
			'Product'=>array(
					'id','brand_id','code',
					'_as'=>'p',
					'_type'=>'LEFT',
			),
			'ProductDescription' => array (
					'name' => 'p_name',
					'_as'=>'pd',
					'_type'=>'LEFT',
					'_on'=>'p.id=pd.product_id'
			),
			'ProductPriceList' => array (
					'qty1',
					'qty2',
					'qty3',
					'qty4',
					'qty5',
					'price1',
					'price2',
					'price3',
					'price4',
					'price5',
					'start_time',
					'intercept_time',
					'status'=>'pplstatus',
					'_as'=>'ppl',
					'_type'=>'LEFT',
					'_on'=>'p.id=ppl.product_id'
			),
			'ProductSuppliers' => array (
					'id' => 's_id',
					'name' => 's_name',
					'_as'=>'ps',
					'_on' => 'ps.id=ppl.suppliers_id'
			) 
	);
}
